﻿    /***************************************************************************************************
    **  Table:	    public.resource
    **  Author:		Zhixian Ong
    **
    **  Description:
    **    
    **    Represents a registered resource.
    **
    **  Modification History:
    **
    **      20140102  Zhixian Ong     - Initial data
    ** 
    **  Status:
    **      Dev
    ** 
    ***************************************************************************************************/

	----------------------------------------------------------------------------
	-- Insert

    INSERT INTO public.resource (name, alias) VALUES ('Test Room 1',     'Test Room 1');
    INSERT INTO public.resource (name, alias) VALUES ('Test Room 2',     'Test Room 2');
    INSERT INTO public.resource (name, alias) VALUES ('Test Room 3',     'Test Room 3');
    INSERT INTO public.resource (name, alias) VALUES ('Test Room 4',     'Test Room 4');
    INSERT INTO public.resource (name, alias) VALUES ('Test Room 5',     'Test Room 5');
    INSERT INTO public.resource (name, alias) VALUES ('Test Room 6',     'Test Room 6');
    
    INSERT INTO public.resource (name, alias, resource_type_id) VALUES ('Pluto1 (10.10.103.3)', 'Pluto1', 19);
    INSERT INTO public.resource (name, alias, resource_type_id) VALUES ('Pluto2 (10.10.103.5)', 'Pluto2', 19);


	----------------------------------------------------------------------------
	-- Select

    SELECT * FROM public.resource;
    